Contains Operator

Syntax

<string expression> contains

<sub-string expression>

Description

The contains operator determines whether a specified string includes a specified substring. The contains operator is case-insensitive, that is, it compares the string regardless of case.

Examples

Type the following lines in the Message Box and press Enter after each: put "Happy Birthday!" into A put "birthday" into B A contains B Oracle Media Objects returns true in the Message Box because "birthday" is a substring of "Happy Birthday!" Create a field and name it "MyBirthday". Type "Happy Birthday" in field "MyBirthday". Then type the following line in the Message Box and press Enter: